-- @owner: ningyali
-- @date: 2024-07-19
-- @testpoint: 数据文件

--step1:建表插入数据; expect:执行成功
DROP TABLE IF EXISTS T_ARAP_RECACCAGE_001 CASCADE;
CREATE TABLE T_ARAP_RECACCAGE_001(
	PK_GROUP VARCHAR2(100 ),
	PK_ORG VARCHAR2(100 ),
	QRYOBJ0PK VARCHAR2(100 ),
	QRYOBJ1PK VARCHAR2(100 ),
	PK_CURRTYPE VARCHAR2(100 ),
	ACCAGEID NUMBER(28,8),
	ACCAGE VARCHAR2(100 ),
	RN NUMBER(28,8),
	DR NUMBER(28,8),
	ACCAGE_QUA NUMBER(28,8),
	ACCAGE_ORI NUMBER(28,8),
	ACCAGE_LOC NUMBER(28,8),
	GR_ACCAGE_LOC NUMBER(28,8),
	GL_ACCAGE_LOC NUMBER(28,8)
) WITH (STORAGE_TYPE=USTORE);
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'7bUg','@y<3Vd]ZfB,bdDf&rio#uiC\]','M.bbt=s!63J"MriZD8p!#9y!NF2h(d^)neeIt-;il?PcO_Djw5FCpVn>N>+A|I(z~r@5P&ROR(`0@#9l@sbdE9s9#&', NULL ,'{iOUD2_R]yciqwKii~bok`#)nBuQj}*A-[0`Sq:Tbn~e', 66876.1950152 , 32508.181294 , 67538.4308841 , 32344.7885672 , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('u~Wy@Ji4\2x]j~B%BTK_)M?];<Xy-c4q~Zp2h@m8Ov(IO!yU_$reHm8(Z|OzGy2OT@\P}s<x4>WkA1x>%$phC"/37<+s4jr)P','dN]%wD&/CE,ZcW<8#96M;%62]2wU;u/I;#)l5$|E[<GoTlMb>WxpRLuj,`)ovRtz@~v^}>^\0l:qW<0N', NULL ,']."BKU7x^=.2jgdN:Ha6\-2QX,jB@`JgE3i8<h9}n7"dz!4@vg&7k~26{*gO*E86`8.7NtZ&yiN91n3E"DZ1`pa~tsIUk8eqUEnJ','rhZ<o#Z0zbGUL=GdL)L6)A#Lr:chlwS1S', NULL , NULL , NULL , 63699.6590054 , 11167.1324777 , NULL , 31961.3906596 , 41786.5363204 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'02(M{I;J)<}X_@%kpD!x6tFj1ujrXXN4-MWP<.?ef%JY0Z@)@3DQX*$>jvR;fEz/Kd|_','v7CY+r88C4mu`ee:e', NULL ,'$rv~>Y`dnK', NULL , NULL , NULL , NULL , 44736.6096363 , 5348.09170711 , 54483.7115022 , NULL , 28230.2234749 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'f;|B$,{D_F4E_e":6F8({&\NJ|>Mqp<$n|J_w0Id/>O~diT3>.[#VV@b5qVUvGf=bl4lXHs','gv@!%D!AD&Zd{mbPg6','XnHTjS}R;`N5OK>v*[<a7ZUqEsZ<!sLibk[P?+eWtmEQGD[<ZD~f^yd1~K@#:G@<KgSssv9P6HaM2$$5RB*L7(D','LtTo9*~*7A0#q1t`|i$Y6KHU!41tm,{wnpnJW>nh#oK~+O|[!.tI_#kl47Swx(3m|fq', 20545.4246285 ,'5.yF1N!,,~WyovL`=a?`PVD]l/QI:11}XT.750PAQfzCY#vy(48;iqiT3', NULL , 7104.50793164 , 56067.611205 , 63751.558748 , NULL , 53021.7754735 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('Y$sa#/(1v]&tB@LX;V]]zTU~V|BgqHnI<znWgvT', NULL , NULL , NULL , NULL , NULL , NULL , 66484.2046045 , 51460.8807744 , NULL , 3040.13030617 , NULL , NULL , 4687.3662276 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'`}<yn&i_','lO>rR".oY12}K:/~LDw&\kQ\pDE%y@`R}ECnUyny~p<.U`7?<_obrSg`j', NULL , NULL , NULL , 44611.8702161 , 17656.1462003 , 24642.1299906 , NULL , 51570.9692516 , NULL , 5096.14299831 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'Ba5ylP)cX2Z`;M', NULL , NULL , NULL , 10392.8258872 , NULL , NULL , 29274.1498498 , 43510.8232526 , NULL , 52640.5006898 , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('l4*PqLcy]N3MNr|H*m-E)bm$%W-qS5^XXsDs~a.nl!(%DNyp-"S{rT]^sqRfh2!M$"TDuZS?d:X_If','50#h$M}H/<Y}#_&oPX(f|}I70-]&QU}KheCvvy|"Ahp1-+d>*&LAK|L|{@<o>$uP*QlEoMj+Q[', NULL , NULL , NULL , NULL ,'1]s7CkY"!"J+$nQ]7D\IUe[|v6~c.n}p0>KJ>;$Ktn.i!yl[=', 52995.5772361 , NULL , 17019.3535836 , NULL , 36869.5368371 , 46058.3720359 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('}{t_2-eL5]"IFZ}/+"ZAukE#(C\OIXiir2RF-1a+<ZLP{3k}!yw!D/PfmZ%gX%x<HSuddMpa@(VJwE}e^<:o*;Zh;Cw0)!XHy=', NULL ,'{pLO(z[b:jxHcbqgC|4$*>\yh<^Y','P<J]Vt`C`_||&Q8.e', NULL , NULL ,'$`]6&6kfsiTYD9j/hyJI0aRJ9uGv{ilj"xZ6}UDH', NULL , 14167.85835 , NULL , 64748.093366 , NULL , 57340.3508091 , 65053.1232098 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'Y~AA):LZ#JgDRnfEt8eTCj(r', NULL , NULL ,'h"By^rq_l@Mh', 46694.1307303 , NULL , 33849.3778476 , NULL , NULL , NULL , NULL , NULL , 21718.740341 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'5&QLj:ZVw.b~8C0F/}vR"So~PwmFhQ5*1{;~biboS$FH8N}Q;N\`81/"z+O1]UJ','fsK*oFt1Sfw-qvonJ+Jp?eP~@Meny(>ru4zgI#1ZJj\Y.0oywGa','M<-%%thFa(', 8828.3918256 ,'_%Xy)!&<+.VS/fc[#YGs-"`a,n3?-SpMNSc0bol4a|%oqCh', 18143.8582597 , NULL , 35382.1532952 , 37022.5975987 , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('S57N|$2Q,N]q5Hm>c]}\M$_9D^M\H2R+vs#vPQ[E0+', NULL , NULL ,'0.t!h9S=TPFIQ?E2_t-hZG>o/F', NULL , NULL , NULL , 11361.9727422 , NULL , NULL , 23655.1628588 , 4939.52305995 , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'u"9iZ0+!Zml-uH}~>4?jPs~=$gTt+}$qJU\;J81/sH\w=J]M~yhwVD', NULL , NULL , NULL , NULL , 11692.6398634 , 12724.9928939 , 24525.2866657 , NULL , 46394.7488019 , 30333.150021 , 1709.69520526 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('>G@LPiJM6.]uW3O7k@OVxvU4uP}??QmioN}-z3b','s~>&_Wn/Bs|")&vy+hqPsgI1t$+', NULL , NULL , NULL , 66573.1970785 , NULL , NULL , NULL , 41394.1544126 , 45663.926975 , NULL , 52768.5249461 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('dISa=Jz_CX}','|.NzLVx8SPF?$jpUX>kB3Z:m5Tn&=U', NULL ,'+*H@5','Sa&s?vpE$E]~G3"{W^+Ui\VqXHNi%)B', 52637.9924522 , NULL , 37936.3785734 , NULL , 21072.6659439 , 22146.9276113 , 62303.5115046 , NULL , 47130.0504961 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'RlaW+<oAe2O~#GtT!%sK6[Pov%Y]z<APurL]_:#)<3U:Y$E@<fhfad}9KlwhPd', NULL , NULL , NULL ,'|eF>7HbBB:eCK[~5H]J"Oiac56&ij#xZVH:|o{o:#4l8.Hn{,NJ<,m.ZBQ|si9.z%rmYN', NULL , 25675.2523155 , 25993.5932489 , NULL , 65065.3874785 , NULL , 15015.8376371 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('0/~]aGz@rv^+$prpgWIeRB~AIzS3srcka[~=ir#{UWPx%sX;n`4.','FuGId?CUrO^}}','DMTU?p"p,6','wb.N-"NF?UNLeY6pAJbi|>#{Av"UyX?$tN|v6Hjoi.@STn$UH:{','vC8<A[o6L<P!=Eet10*BW/sTW.Z^*o++!', 57155.1822961 ,'yCvnj1"Jn;g^%o52DxpJkXO()<&BCYBP/(m`wHx,tOq?Z.{+A><hQvG<5o[1a[r4+vz.R\xUBg', 49864.6407437 , 20454.7323411 , 18256.3829228 , 42027.9894766 , 47953.3922682 , 4182.65989416 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('^HdRpVW5"*z{YP]DIM&W6#BSbrgdycET#pZG.`!2*s#[-+)%w&?t@QX#','2q2ZXJ{gX@c`c^0E_9k.Z`~~`e9sY8`i(rF*yb6;3u81&oMlH_Q+GM8Ek}Su,:[HMEa', NULL ,'8dxD4j#:AIi\c<]O{#;`+P+q"e.D\`Ne', NULL , NULL ,'b28NR!U`,#AvMby95[;T\"RhCc9nUJtiMXw\fmpZ}]MVzmM"O5~EfoQ)FX[1`Et\gdhq\=YyGyB1t6@n0|~A|w', 42871.1830239 , NULL , 20632.6719666 , 62.91527406 , 35949.378344 , 50453.4839294 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('M"$PNR`s4yRvgrv*z)?#m`em%GKqN9]G>A1Sli&,YOyyowHQ9M!E]`B<y','-*3tFH;0jL@~hgJHbI}i>%)J#:$DqfgEpkz~,?V"kPG8s', NULL , NULL ,'Mv6|h}s9zFSQ]UO;},_`mPKKCu#D[<5x;RJe|^Q@WE)]FH&', 59075.0626479 ,'R~%ICL,i1%g|`K1xwrEJYkDG/L&TqI?^]>\;wHF}s-Ivp2&wf%nb', NULL , NULL , 19115.8338266 , 54518.2626181 , NULL , NULL , 44270.286849 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'z~>`w&2dov@lLz*--mILDro3cS%Tg9"`hJj$Fl?\*SSo:4434nS9I$j','RaKD_TN#y}U`PiLll-qyoS`Gp~8wW88qXvt|\H&', NULL , NULL , NULL , 34723.9820286 , NULL , NULL , NULL , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'OcJ%z\n$VHV\HMNi<@5Q|m8L0at5JsG7",9rqzq#7>r?A@Z)-x>,F1in|=`U\U|`[+U6UtL5Rc=b%vvq^"F', NULL , NULL , NULL , NULL ,'-Q*liZ`u_kG;nr_mny01u<rk\w24~A}<WEm2ecjn??P1>bxM:@', NULL , NULL , 7536.66792738 , NULL , 13545.9813145 , 30313.418463 , 59269.488578 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('!~:/M}|?Zp$RxpdVQu{XVs&UiN[%r/c%Riy?7#UA#X2!<TcbT^~,fg/raEjH("a;=1h', NULL ,'KSY$QW}rvb{j$l4W5}H,d%Z@lAF`%eFQ', NULL ,']|p)-)jJ#`I2]u4|i-094wUe(NX*a`WwcLS6j79]p9$x4naL|mA[iM.4nFMR%UCi6"zGqt6Ic,G3!scKT8x:5,t<;5u)(', NULL ,'Y@3<\|#dNE~d+gozAeuQEi?+,M4RU53G}~n"5h2$){B/JN', NULL , NULL , 24627.960753 , 62738.8436125 , NULL , 25493.1814233 , 59482.3593812 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'huOcQH:302uYb^sP|5yq2Eoez.r>sh9[D@=7/[9~', NULL , NULL , NULL , NULL , NULL , NULL , 6957.45579513 , 3489.72963912 , 28773.3291902 , NULL , NULL , 46569.0247785 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL , NULL ,'\NO?uYKw!t+nFmF^xN[ZX(V%C)PJ6&f}H1B9%;bK"', NULL , 42845.3104806 , NULL , NULL , 65192.3340114 , 63843.8769417 , 24310.9982676 , NULL , 31879.8232106 , 65727.946813 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL ,'V@^jl;wTsv%bVLPv1];-te?swDL0}9\h%^V}FaRKaYnA2o[O#@8&oZDI7IjcjqEh9J+3?15','spGFlxGNx:e-{<SB=F7RQnou]N3jB4$~XoAc$nrqRbf%)+7{]eKacxi_0MS:4:-Tt[-"<g','Hdl!aUCL+1u', 51780.2377976 ,'"%7&i=1F^QDbWCUTZj]<hc\sO.)b7$bY6_Y}m;{-8x9uro]3_VVS[R&*J1ts%/>D>cUNM\YGnRj`ca#gT', NULL , NULL , NULL , NULL , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('9?x%qKcsd6-ef\)Qd}x5h$P96Fu}&X}s9lOEJtt7D{[eyj54g6pl@7R*OI{?$S8E!T?"r7dNh','~ei:)8SFY<#aFp$ay,n,F3>]^F!]M:WaBZd%2VtOS7$|B)q&~F[x0@!M', NULL ,'?vp$++@uK_uEx1*lqEEVD5D|BdhP6%k}CGV}&6|{ho{Gq|<z/JF3C[dbeD5M+u+.E&i)7I9RAZf&ntxc*', NULL , 16804.0344357 ,'Pop*D8Q=="e&&L!37wODby?,:A2$Dg\}#?7,8<^Nf%:)>o3U=1xFHIHk@Gv,4D3k)Db', NULL , NULL , 17533.3710982 , 47431.0180305 , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'IQN0Wn-y!Z)[yKs9U43YwMZvY4Ut$=Rz^ay)z0Ex8^pmr6.gD!}unZGea', NULL ,',9_ovN_37,Dn\"`=@8(IR{-zBb9F{]T#E:@*nSk.G_=H^t(L$W0AG/#$vPGf4asg05UuMobn','CV<nq19C?V[P/BG[&O&"MAvX3f)Cg3X*{mPuM@)K0Otid>0X:Iax`N=fAi8gw4"8-,@yiC5@6AQPIWK"1&', 14787.3816564 ,'JC#BufGq^ua(95+r9M]LU:p=g@', 48831.6260284 , 66195.844479 , 6677.21984439 , 18279.53447 , NULL , 53062.1595906 , 44329.9749994 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'m%nI>(V7!V0i!zdzoE3#>zc@BO+<Of$zwRs', NULL , NULL , NULL , NULL , NULL , 59010.1428514 , NULL , 25587.7435759 , 39993.7572624 , NULL , 48258.2031319 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL , NULL , NULL , NULL , NULL , NULL ,'58!.KQ0^N5AqZ%GNMpY/R<zhT*aHd_0i/.=}Rlvs"CU"Wej>/mh1A2#.X!Vk32$&ugjWiGsi', 47075.2329618 , NULL , 65353.4507459 , NULL , NULL , 49942.6556566 , 40401.364273 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'HT6\t=3x~&R!l#2L10D.fg[DSg1J_gSr$NEy?;&vda(+Mw.{xF[zzP/aMdRFtTCfAoqbBCp.', NULL ,'RI}pA]wn">\^g(V<w.cnk,Lct{4%+iQD<yL@TZXh7=B.ygtC>@Z~V1"ETpFMjZX.(uj&z$g*^l','8.jz22M+jrM2NIW7p+{B4xS!Vg];i*0^+V%eu[>%jXdO&_VDEUlR|Z1;@CY`js0BN$', NULL ,'A2qKhpP+`k?sznRtN4SKpB@=2tQ`t7OXlVy&<@+1K&m7}6NnXpzj$2.D5i&3&f4]-4^D~$B*hfh.Q*,z1c4V', NULL , 44271.4435254 , NULL , 64271.7753703 , 25197.1834012 , NULL , 48685.3578843 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'r~+?eZu[k}TCv?InJ"!|(u1trIX_$mV<lL9jlE#ld"INgx%JG+>!0T=dOfj)#Yzk3YCbU$8\"V&R?]s6L:d.3$u&Ql[c','xH@m8A=>dn!"a;`$T.}UqEhZjo&AD#r9T:F)I.sflDAa8Qo$*s%U},)-?tD+EE0V%U4NgK,C}','jF(6{3IwnCT?WSUBQhLY_2i','~"&V`0k|bZ{N9;+d[aF.oBY/K#IHgv7hsyA0hBJU!5Cn_iPr', 14115.7788436 , NULL , 31397.8936965 , 57099.6378814 , 18490.1683367 , 33432.1980061 , NULL , 12645.1975504 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,';,3-vIzwAQfFe2q\ZXM:6ZR,^Gm:0B#_+x>4&DVj_Cf{d+%;Qs-Si-IXQp%JaN4=E<YwA;[qC1c`','63"AB,Me?RryB5|PX4z/@^0#>jLt{4#8"Vo>2]*CIgR{6oM0yz](UGRO~M^Z9-dk6;', NULL ,'a`vDYJ!,\t|g8?:tMmMbMV', NULL , NULL , 5024.18172654 , 24347.3642532 , 52741.3104322 , NULL , NULL , 1947.15105104 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('?If*>vv-Yl3E431gmD$n|Ka:m4T_Z~z9x-tQn6xk2>?*CvDREnHc7xuR','w%\K;L$l?T^F/\4o-~1+su9h:_aein>B!a~1v[[fGg/Tkgf$`.LJ!@I8kyQ*{dGW#yZ;e9u','S$t!KjE|\BaJ?/dz]9,"b/6@0o', NULL ,'DKE6c~dnKVIeDO(M]-,7tt|8h$7^a(|zU=p(at7t', 2066.97837409 ,'8wD|e', 49482.2719928 , NULL , NULL , NULL , 36262.5350343 , 34150.9059338 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('WoJ{;AYB2`V$S]BU\KTm.?GhN?g<TeY9n<e2[glq2JQ;/F+hh%2m5Lc-!_;AkT3Afb', NULL ,'h03z(>*vV$;LK|W7ag*L+cFIc5G-9!@#fn5iVkj"Hh|hCYl-0`$8CE<-Uq]?bFODbHMkkKO7', NULL ,'c|H6N>t,*uP\MO49mVa?%U_9kLnXrcMG?PS_g?{5(5IH/aJY%feuI:aM&@3H~TQP(y&Ayh>MCP{jXXt8/YS\6k[K[+V+', NULL ,'H,a6MkYtBsOWwfn\}?D4);F|#EnXMU]=g<.KKZT[|"]t<)(\d', 47015.3431845 , NULL , 24420.9623143 , NULL , 63499.132126 , 30123.7337743 , 29354.996905 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('4ako(6qy?R2?','<".<OE$)0U$-t^3~_M@YRI\E><4*i8N(0wr|aYV2[X+qn#yvG.HW','Kn[~xw|.Na]dE.E@e%1m2LVelY6Vsvth(4R1)\K#B#q?#TcmW6U?[^6J~;.lF{d+f4V)',':*-#8A%CVyfTs+%uCJUH4]S!H855%CQ<^VO~n>4G;{"u{".5uM3{wzGZF@cM2YDS:liUMsb]k', NULL , NULL ,'Ma9V1`o3xJ5!C(672$-8*84cl`pjz4_<c3JiW-3bvNfVuOK)m[XomITP&?/l`:`*^=5[u>{%P9R_uN8=x:9j,Y', 46607.8196232 , 38790.6666178 , 16440.137819 , NULL , 840.687167991 , NULL , 10862.1038846 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('1B!RD@=^d;7H^o6jcoo2LEf2@6@P*g&?%A:vEC]N:39EQy3)dldv7zmMEsVRl-*f7GxXBxk<Eux7h6v!Mo:!?IKqJb$Ch-', NULL , NULL , NULL , NULL , 48722.4293934 , NULL , 65095.2821483 , NULL , 56129.1917461 , NULL , 52210.5720721 , 15589.6040174 , 17889.0027339 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('@_Rpa\O%4RxqMZ@\m"wb{py"Q]!6/','7i#(`S]$/b(`"D3Yc>\SSS=]+/\dXcw,\+rc"Ao.]:F\Z"q[.)gA>j/?G{I-RmGelI7*R@kv(T$|?x-,3X','Ly#]+XC]R)+l1G"^eS%R/8TxdaLxB#lr6Y\eqFv>mHnJs-~p!dM5zFH]', NULL ,'I;]!v`y-[8v+spxCnP$<imU}]p@bLX)P5~JtN/5', NULL , NULL , 19687.1177563 , 48745.2236778 , 9256.43479756 , 67197.4096055 , 25607.1172695 , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('qVc`$', NULL , NULL ,'t(c[P~dU,`-7~AN', NULL , NULL ,'T8sFxo:3^EQtLL,2053G2dbyub$%Lp,', 32557.9819667 , NULL , 13876.4576374 , 21342.7701563 , 46006.0092636 , 39936.2775962 , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'tROz','@AZWvR?BNM)RCVI6I#eY6s!edxiV<."k#C', NULL ,'WVV"I#^A>U{<)k.A:P-zt', NULL ,':Zzy<L|gwXCk2W$@/vwC_aX#]FH', 63165.9935996 , 55329.6328233 , NULL , NULL , 27380.7658318 , 25885.1828732 , 19144.8305906 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('%s)R[<', NULL , NULL ,'TBadE=2Xj7CH{r01j#?$0|_\|QwH*b!dd,N8fEzi@]j`Q_"Hdk@.JX*eF;Gm7MW<ay8+hw>O^0hA20##Eh(a8', NULL , 58795.6590337 ,'Z8!90q.>]%E#`om6cjM[[tHb|X[]1c%5gXvMYd&!xZ<D4P%{(Vy,Xe$u!d45<$XWI9T_U1oo', 14677.4666948 , NULL , NULL , NULL , 26706.8579102 , NULL , 31202.3260073 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'[=QXtV@,w!dyF_l(Zys9i~yve;bbG2vIapGsQ])nwy-)W&(6rU):}XPu<u','9\s;Q1A=,?sbW@#G:Mk3mO#x(9];n3Ngh%Hy1oUMM7u0}"X/8t/t(=j8kNjU`', NULL , NULL , 39831.2950146 , NULL , NULL , NULL , NULL , NULL , 7661.75453407 , 342.989806283 , 15436.3461397 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('`rl&{g@{Or[o}3[c)L12\Vw[%]{R$TSt3S|3g|yGwkK}#>P','e_Y#.%FEY^@Tl3$oOp|C4./Ol{mhQ,!#*Wg?.gLbm$)','<38FCG|&\#To$A(}5(.IpmjZ3dv`O/r]Eu|~[Z*NPeq1Y;T-t', NULL , NULL , NULL ,'IDUx{4%hr%{$,It&', NULL , 42154.5524232 , NULL , 33772.8937193 , NULL , NULL , 59837.6129344 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('fA7Iz0mOz`C9^|DGJ&Z)1p"0EAEbe', NULL ,'nKj,Y)R^Vo,&/;zvnb?p+fUc)=:CYo','=Y^}If,:$^*(\rQX!Z`?+a0r@-A8`gN^A2KxTZH{JWBlOGr/1g"/', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'_C>=z99OaEnGV[apt?','&;j(Xu~D;P>&qLpoKs', NULL , NULL , NULL , NULL , 34497.6905067 , NULL , 55793.1075166 , NULL , 63862.8481674 , 23021.9115224 , 56576.4491696 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES (',1&_UsW=;h!2uX@*NfmU:-y.Jfd?HXez>.Pz!C+Bi+,*tv#{6q#rl6>:z%PD#ioyG/d[}', NULL ,'-44=%Fa>6AQ)*elr?', NULL , NULL , NULL ,'Q>k9ci:;\g|Xgmk&){C3_ZN>*j}goz%;W+hrhNY[DG2&LpZ*8PX~PCRRA_9e%"i6vqG', 7197.14571474 , NULL , NULL , NULL , NULL , NULL , NULL ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ('o>H}^2KLnq{Zdh7ca2>V$6Q<dJ.M:)v4*>hlp]|Dx6YayFZqV!V;n;_7%k]><pE&8SlKh?5','<eV&07u`w:xCOV-ls8GN2w8f/8H%ja_Nomt=6Ot~K`wTFH4($.#)Ta|GL|1[,l88sfuqwm', NULL , NULL ,'p=C:T3w(9\(xiI#PKNo~bxx/RG2poVGqL&HAy|`.id,s6/(Gn)XYT)1[MkKo5u0.z', NULL , NULL , 4825.40255212 , NULL , 14730.6099874 , NULL , NULL , NULL , 45929.8134503 ) ;
INSERT INTO T_ARAP_RECACCAGE_001 VALUES ( NULL ,'/&m2q:w\HzJ~~M]hp4BW=y7"Dm3e{','0>*V}pVT7**oXyoXrlMSmtzm7{WI.Q&awvdH+jJkhY|+=', NULL ,'`kkf&!Uri9QdE', NULL ,'t=8]/d3{@_xQmFCXG\d29{SvwDLnu+&\J`r=MPdQ-,o`wbvu<|rf2)uNiI&N{Ds_|#Q{aE0HM[^<<mnRKF5ta', 46553.2421653 , 34379.7819491 , 41234.5733814 , NULL , 37904.1424902 , 42828.8178458 , 50699.8906982 ) ;
insert into T_ARAP_RECACCAGE_001 select * from T_ARAP_RECACCAGE_001;
insert into T_ARAP_RECACCAGE_001 select * from T_ARAP_RECACCAGE_001;

DROP TABLE IF EXISTS T_ARAP_RECACCAGE_002 CASCADE;
CREATE TABLE T_ARAP_RECACCAGE_002(
	PK_GROUP VARCHAR2(100 ),
	PK_ORG VARCHAR2(100 ),
	QRYOBJ0PK VARCHAR2(100 ),
	QRYOBJ1PK VARCHAR2(100 ),
	PK_CURRTYPE VARCHAR2(100 ),
	ACCAGEID NUMBER(28,8),
	ACCAGE VARCHAR2(100 ),
	RN NUMBER(28,8),
	DR NUMBER(28,8),
	ACCAGE_QUA NUMBER(28,8),
	ACCAGE_ORI NUMBER(28,8),
	ACCAGE_LOC NUMBER(28,8),
	GR_ACCAGE_LOC NUMBER(28,8),
	GL_ACCAGE_LOC NUMBER(28,8)
) WITH (STORAGE_TYPE=USTORE);

drop table if exists t_group_by_data_001 cascade;
create table t_group_by_data_001(
COL_1 integer,
COL_2 bigint,
COL_3 double precision,
COL_4 decimal(12,6),
COL_5 bool,
COL_6 char(30),
COL_7 varchar2(50),
COL_8 varchar(30),
COL_9 interval day to second,
COL_10 TIMESTAMP,
COL_11 date,
COL_12 date,
COL_13 TIMESTAMP WITHOUT TIME ZONE,
COL_14 blob,
COL_15 clob,
COL_16 int[]
) WITH (STORAGE_TYPE=USTORE);
drop table if exists t_group_by_data_002 cascade;
create table t_group_by_data_002(
COL_1 integer,
COL_2 bigint,
COL_3 double precision,
COL_4 decimal(12,6),
COL_5 bool,
COL_6 char(30),
COL_7 varchar2(50),
COL_8 varchar(30),
COL_9 interval day to second,
COL_10 TIMESTAMP,
COL_11 date,
COL_12 date,
COL_13 TIMESTAMP WITHOUT TIME ZONE,
COL_14 blob,
COL_15 clob,
COL_16 int[]
) WITH (STORAGE_TYPE=USTORE);


--创建序列
drop sequence if exists group_by_seq;
create sequence group_by_seq increment by 1 start with 10;

--清空数据
truncate table t_group_by_data_001;

--插入数据
begin
	for i in 1..50 loop
      insert into t_group_by_data_001 values(
	  i,
      group_by_seq.nextval,
	  i+445.255,
	  98*0.99*i,
	  true,
	  lpad('abc','30','@'),
	  lpad('abc','30','b'),
	  rpad('abc','30','e'),
	  (INTERVAL '4 5:12:10.222' DAY TO SECOND(3)),
	  to_timestamp('2019-01-03 14:58:54.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
	  to_date('2018-11-03 14:14:12'),
	  to_date('2019-01-03 14:14:12'),
	  to_date('2019-01-03 14:14:12'),
	  '100101010101010',
	  rpad('abc','9','a@123&^%djgk'),
	  '{32,535,5645645,6767,76,67,56,48,979,978,7}'
	  );

    end loop;
end;
/
insert into t_group_by_data_001 select * from t_group_by_data_001;
insert into t_group_by_data_002 select * from t_group_by_data_001;


drop table if exists  t_join_base_001 cascade;
drop table if exists  t_join_base_101 cascade;
drop table if exists  t_join_base_102 cascade;
drop table if exists  t_join_base_103 cascade;
drop table if exists  t_join_base_104 cascade;
drop table if exists  t_join_base_105 cascade;
drop table if exists  t_join_base_201 cascade;
drop table if exists  t_join_base_301 cascade;
drop view  if exists v_t_join_base_101;
drop view  if exists v_t_join_base_102;
drop view  if exists v_t_join_base_301;

--大表
create table t_join_base_001(
id int,c_int int,c_real real,c_float float,c_decimal decimal,c_number number,
c_char char(10),c_vchar varchar(10),c_vchar2 varchar2(100),c_clob clob,
c_long clob,c_blob blob,c_raw raw(100),c_date date,c_timestamp timestamp) WITH (STORAGE_TYPE=USTORE);
insert into t_join_base_001 values(1,1000,100.123,100.456,100.789,100.123,'abc123','abcdefg',lpad('123abc',50,'abc'),lpad('123abc',50,'abc'),'11100000010101011100','111000010101011100','11100011010101100',to_timestamp(to_char('1800-01-01 10:51:47'),'yyyy-mm-dd hh24:mi:ss'),to_timestamp(to_char('1800-01-01 10:51:47'),'yyyy-mm-dd hh24:mi:ss'));
insert into t_join_base_001 values(0,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
--小表
create table t_join_base_101 WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;
create table t_join_base_102 WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;
create table t_join_base_103 WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;
create table t_join_base_104 WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;
create table t_join_base_105 WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;
--1行数据的表
create table t_join_base_201  WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001 where id=1;

create table t_join_base_301  WITH (STORAGE_TYPE=USTORE) as select * from t_join_base_001;

--插入数据

CREATE or replace procedure proc_insert(tname varchar,startall int,endall int) as
sqlst varchar(500);
BEGIN
  FOR i IN startall..endall LOOP
		sqlst := 'insert into ' || tname ||' select id+'||i||',c_int+'||i||',c_real+'||i||',c_float+'||i||',c_decimal+'||i||',c_number+'||i||',c_char'||',c_vchar||'||i||',c_vchar2||'||i||',c_clob||'||i||',c_long||'||i||',c_blob'||',c_raw,c_date,c_timestamp from '||tname|| ' where id=1';
		raise info '%',(sqlst);
        execute immediate sqlst;
  END LOOP;
END;
/

call proc_insert('t_join_base_001',1,20);
call proc_insert('t_join_base_001',1,20);
call proc_insert('t_join_base_101',1,10);


--视图
create view v_t_join_base_101 as select * from t_join_base_101 where id<90;
create view v_t_join_base_102 as select * from t_join_base_102 where id<9;
create view v_t_join_base_301 as select * from t_join_base_301;

--索引
create index idx_join_base_001_1 on t_join_base_001(c_int);
create index idx_join_base_001_2 on t_join_base_001(c_int,c_vchar);
create index idx_join_base_001_3 on t_join_base_001(c_int,c_vchar,c_date);

create index idx_join_base_101_1 on t_join_base_101(c_int);
create index idx_join_base_101_2 on t_join_base_101(c_int,c_vchar);
create index idx_join_base_101_3 on t_join_base_101(c_int,c_vchar,c_date);

create index idx_join_base_102_1 on t_join_base_102(c_int);
create index idx_join_base_102_2 on t_join_base_102(c_int,c_vchar);
create index idx_join_base_102_3 on t_join_base_102(c_int,c_vchar,c_date);

create index idx_join_base_103_1 on t_join_base_103(c_int);
create index idx_join_base_103_2 on t_join_base_103(c_int,c_vchar);
create index idx_join_base_103_3 on t_join_base_103(c_int,c_vchar,c_date);

create index idx_join_base_104_1 on t_join_base_104(c_int);
create index idx_join_base_104_2 on t_join_base_104(c_int,c_vchar);
create index idx_join_base_104_3 on t_join_base_104(c_int,c_vchar,c_date);

create index idx_join_base_105_1 on t_join_base_105(c_int);
create index idx_join_base_105_2 on t_join_base_105(c_int,c_vchar);
create index idx_join_base_105_3 on t_join_base_105(c_int,c_vchar,c_date);

create index idx_join_base_301_1 on t_join_base_301(c_int);
create index idx_join_base_301_2 on t_join_base_301(c_int,c_vchar);
create index idx_join_base_301_3 on t_join_base_301(c_int,c_vchar,c_date);

--step1: 建表;expect:成功
drop table if exists t_group_by_001 cascade;
create table t_group_by_001(
col_1 bigint, col_2 timestamp without time zone, col_3 bool,col_4 decimal,col_5 text ,col_6 smallint ,
col_7 char(30),col_8 double precision,col_9 text,col_10 character varying(30),
col_11 bool ,col_12 bytea ,col_13 real ,col_14 numeric ,col_15 blob ,col_16 integer ,
col_17 int ,col_18 timestamp without time zone ,col_19 binary_integer ,col_20 interval day to second ,
col_21 boolean, col_22 nchar(30) ,col_23 bigint ,col_24 nchar(100) ,col_25 character(1000) ,
col_26 text , col_27 float ,col_28 double precision ,col_29 bigint ,col_30  timestamp without time zone ,
col_31 timestamp , col_32 clob ,col_33 interval year to month, col_34 character(30) ,col_35 smallint ,
col_36 blob ,col_37 char(300),col_38 float ,col_39 raw(100),col_40 clob ,
col_41 binary_double ,col_42 number(6,2) ,col_43 decimal(6,2) ,col_44 varchar2(50),col_45 varchar(30) ,
col_46 nvarchar2(100), col_47 numeric(12,6),col_48 varchar2(50),col_49 date,col_50 clob ,
col_51 integer ,col_52 binary_double ,col_53 decimal(12,6),col_54 raw(8000),col_55 clob ,col_56 varchar2(8000) ,
col_57 date ,col_58 number(12,6),col_59 nvarchar2(4000) ,col_60 clob ,
col_61 blob ,col_62 date ,col_63 blob , col_64 varchar(1000),col_65 date,
constraint t_group_by_pk primary key(col_1)
) with (storage_type=ustore);
--step2: 创建序列;expect:成功
drop sequence if exists seq_group_by_001;
create sequence seq_group_by_001 increment by 1 start with 100000;
--step3: 清空数据;expect:成功
truncate table t_group_by_001;
--step3: 插入数据;expect:成功
begin
 for i in 1..1000 loop
      insert into t_group_by_001 values(
   seq_group_by_001.nextval,to_timestamp('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
   true,3.1415926+seq_group_by_001.nextval,lpad('abc','5000','a@123&^%djgk'),
   i,lpad('abc','30','@'),i+1.456789445455,lpad('abc','5000','a@123&^%djgk'),lpad('abc','30','b'),
   false,'010101111111100000000000000',3.1415926+seq_group_by_001.nextval,i/4,'010101111111100000000000000',
   i,i,to_timestamp('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),'1',
   (interval '4 5:12:10.222' day to second(3)),
   0,rpad('abc','30','e'),seq_group_by_001.nextval,rpad('abc','100','exc'),lpad('abc','1000','a@123&^%djgk'),
   lpad('abc','5000','a@123&^%djgk'),i/4,seq_group_by_001.nextval-99,i*3.1415,to_timestamp
   ('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
   to_timestamp('2019-01-03 14:58:54.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),lpad('abc','5000','a@123&^%djgk'),
   (interval '12' year),rpad('abc','30','&'),i,'010101111111100000000000000',rpad
   ('abc','300','exc'),i/2.15,'0FAADB9',lpad('abc','5000','a@123&^%djgk'),
   1.0E+100,3.14+i,i+445.255,rpad('abc','30','&'),lpad('abc','30','&'),rpad('abc','100','&GDsh'),
   125563.141592,rpad('abc','30','e'),to_timestamp('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
   lpad('abc','5000','a@123汉字&^%djgk'),
   seq_group_by_001.nextval+2,-1.79E+100,98*0.99,'01010',lpad('abc','5000','a@123&^%djgk'),
   rpad('abc','8000','a@123&^%djgk'),to_timestamp('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
   25563.1415,lpad('abc','3000','a字符串@123&^%djgk'),lpad('10',2000,'01010'),
  '01010',to_timestamp('2019-01-03 14:14:12.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),'010101111111100000000000000',
  rpad('abc','1000','&GDsh'),to_timestamp('2019-01-03 15:19:00.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF')
   );
    end loop;
end;
/
